Columns
Indexes
Grants
Dependencies
Details
Columns
Indexes
Grants
Dependencies
Details
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
SID | NUMBER | Yes | null | 1 | null |
OBJ | VARCHAR2(20 BYTE) | Yes | null | 2 | null |
ID | VARCHAR2(100 BYTE) | Yes | null | 3 | null |
TITLE | VARCHAR2(100 BYTE) | Yes | null | 4 | null |
LIAISON_TYPE | VARCHAR2(4000 BYTE) | Yes | null | 5 | null |
LIAISON_LEVEL | VARCHAR2(4000 BYTE) | Yes | null | 6 | null |
LIAISON_DATE | DATE | Yes | null | 7 | null |
NARRATIVE | CLOB | Yes | null | 8 | null |
CREATED_BY | VARCHAR2(100 BYTE) | Yes | null | 9 | null |
CREATED_ON | DATE | Yes | null | 10 | null |
LAST_MODIFIED_BY | VARCHAR2(100 BYTE) | Yes | null | 11 | null |
LAST_MODIFIED_ON | DATE | Yes | null | 12 | null |
OBJ_TYPE | VARCHAR2(100 BYTE) | Yes | null | 13 | null |
ANALYSIS_TYPE | VARCHAR2(4000 BYTE) | Yes | null | 14 | null |
INDEX_OWNER | INDEX_NAME | COLUMNS | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | COLUMN_EXPRESSION | JOIN_INDEX |
---|
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OBJECT_ID | OWNER | OBJECT_TYPE | OBJECT_NAME | STATUS | TYPE_LINK |
---|
References
NAME | VALUE |
---|---|
CREATED | 18-OCT-24 |
LAST_DDL_TIME | 07-FEB-25 |
OWNER | QART |
MVIEW_NAME | MV_BEHAVE_SCI_FILES |
CONTAINER_NAME | MV_BEHAVE_SCI_FILES |
QUERY | select l.SID, l.OBJ, l.ID, l.TITLE, r.display LIAISON_TYPE, rl.display LIAISON_LEVEL, l.LIAISON_DATE, l.NARRATIVE, l.CREATED_BY, l.CREATED_ON, l.LAST_MODIFIED_BY, l.LAST_MODIFIED_ON, ot.display OBJ_TYPE, '' ANALYSIS_TYPE from acm.t_f_liaison l inner join acm.t_acm_obj o on l.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid left outer join acm.t_acm_reference r on l.liaison_type = r.ref_key left outer join acm.t_acm_reference rl on l.liaison_level = rl.ref_key union all select ba.sid, ba.obj, ba.id, ba.title, '' LIAISON_TYPE, '' LIAISON_LEVEL, null LIAISON_DATE, ba.narrative, o.CREATED_BY, o.CREATED_ON, o.LAST_MODIFIED_BY, o.LAST_MODIFIED_ON, ot.display OBJ_TYPE, r.display analysis_type from acm.t_f_behavioral_analysis ba inner join acm.t_acm_obj o on ba.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid left outer join acm.t_acm_reference r on ba.analysis_type = r.ref_key union all select rnd.sid, rnd.obj, rnd.id, rnd.title, '' LIAISON_TYPE, '' LIAISON_LEVEL, null LIAISON_DATE, rnd.narrative, o.CREATED_BY, o.CREATED_ON, o.LAST_MODIFIED_BY, o.LAST_MODIFIED_ON, ot.display OBJ_TYPE, '' ANALYSIS_TYPE from acm.t_f_rnd rnd inner join acm.t_acm_obj o on rnd.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid union all select te.sid, te.obj, te.id, te.title, '' LIAISON_TYPE, '' LIAISON_LEVEL, null LIAISON_DATE, te.narrative, o.CREATED_BY, o.CREATED_ON, o.LAST_MODIFIED_BY, o.LAST_MODIFIED_ON, ot.display OBJ_TYPE, '' ANALYSIS_TYPE from acm.t_f_train_edu te inner join acm.t_acm_obj o on te.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid |
QUERY_LEN | 1633 |
UPDATABLE | N |
UPDATE_LOG | null |
MASTER_ROLLBACK_SEG | null |
MASTER_LINK | null |
REWRITE_ENABLED | N |
REWRITE_CAPABILITY | TEXTMATCH |
REFRESH_MODE | DEMAND |
REFRESH_METHOD | FORCE |
BUILD_MODE | IMMEDIATE |
FAST_REFRESHABLE | NO |
LAST_REFRESH_TYPE | COMPLETE |
LAST_REFRESH_DATE | 07-FEB-25 |
LAST_REFRESH_END_TIME | 07-FEB-25 |
STALENESS | FRESH |
AFTER_FAST_REFRESH | NA |
UNKNOWN_PREBUILT | N |
UNKNOWN_PLSQL_FUNC | N |
UNKNOWN_EXTERNAL_TABLE | N |
UNKNOWN_CONSIDER_FRESH | N |
UNKNOWN_IMPORT | N |
UNKNOWN_TRUSTED_FD | N |
COMPILE_STATE | VALID |
USE_NO_INDEX | N |
STALE_SINCE | null |
NUM_PCT_TABLES | 0 |
NUM_FRESH_PCT_REGIONS | null |
NUM_STALE_PCT_REGIONS | null |
SEGMENT_CREATED | YES |
EVALUATION_EDITION | null |
UNUSABLE_BEFORE | null |
UNUSABLE_BEGINNING | null |
DEFAULT_COLLATION | USING_NLS_COMP |
ON_QUERY_COMPUTATION | N |
DUPLICATED | N |
SHARDED | N |